Á¤º¸°úÇÐȸ ³í¹®Áö B : ¼ÒÇÁÆ®¿þ¾î ¹× ÀÀ¿ë
Current Result Document :
ÇѱÛÁ¦¸ñ(Korean Title) |
´ÙÂ÷¿ø ÆÄÀϱ¸Á¶¸¦ À§ÇÑ ¹°¸®Àû µ¥ÀÌÅͺ£À̽ºÀÇ ¼³°è ±â¹ý |
¿µ¹®Á¦¸ñ(English Title) |
A Physical Database Design Method for Multidimensional File DOrganizations |
ÀúÀÚ(Author) |
ÀÌÁ¾ÇÐ
±è»ó¿í
ÀÌ¿µ±¸
Ȳ±Ô¿µ
Jonghak Lee
Sangwook Kim
oungkoo Lee
Kyuyoung Whang
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 24 NO. 07 PP. 0705 ~ 0721 (1997. 07) |
Çѱ۳»¿ë (Korean Abstract) |
º» ³í¹®¿¡¼´Â ´ÙÂ÷¿ø ÆÄÀϱ¸Á¶¸¦ À§ÇÑ ¹°¸®Àû µ¥ÀÌŸº£À̽º ¼³°è ±â¹ýÀ» Á¦¾ÈÇÑ´Ù. ¹°¸®Àû µ¥ÀÌŸº£À̽º ¼³°è´Â ÃÖÀûÀÇ ÁúÀÇó¸® ¼º´ÉÀ» Á¦°øÇϱâ À§ÇÏ¿© µ¥ÀÌŸº£À̽º ÈÀÏÀÇ ÀúÀå ±¸Á¶¿Í ¾×¼¼½º ±¸Á¶¸¦ °áÁ¤ÇÏ´Â °úÁ¤ÀÌ´Ù. Áö±Ý±îÁö ´ÙÂ÷¿ø ÈÀϱ¸Á¶¿¡ °üÇÑ ¸¹Àº ¿¬±¸°¡ ¼öÇàµÇ¾î ¿ÔÀ¸³ª ¹°¸®Àû µ¥ÀÌŸº£À̽º ¼³°èÀÇ Ãøº¯¿¡¼ÀÇ ¿¬±¸´Â ¼öÇàµÈ ¹Ù°¡ ¾ø¾ú´Ù. º» ³í¹®¿¡¼´Â ¸ÕÀú ÁúÀÇó¸®ÀÇ ¼º´ÉÀÌ ÁÖ¾îÁø ÁúÀÇ ¿µ¿ªÀÇ ¸ð¾ç°ú µµ¸ÞÀÎ °ø°£ÀÇ ºÐÇÒ»óŸ¦ ³ªÅ¸³»´Â ÆäÀÌÁö ¿µ¿ªÀÇ ¸ð¾ç »çÀÌÀÇ À¯»ç¼º¿¡ µû¶ó Å©°Ô ¿µÇâ ¹ÞÀ½À» º¸ÀÌ°í, ÀÌ·¯ÇÑ Æ¯¼ºÀ» ÀÌ¿ëÇÏ¿© ÁúÀÇó¸®ÀÇ ¼º´ÉÀ» Çâ»ó½Ãų ¼ö ÀÖ´Â ´ÙÂ÷¿ø ÈÀϱ¸Á¶ÀÇ ÃÖÀû ±¸¼º ±â¹ýÀ» Á¦¾ÈÇÑ´Ù. ¶ÇÇÑ, ¼º´É Æò°¡¸¦ À§ÇÏ¿© ´ÙÂ÷¿ø ÈÀϱ¸Á¶ÀÇ ÇϳªÀÎ °èÃþ ±×¸®µå ÈÀÏÀ» ±¸¼ºÇÒ ¼ö ÀÖÀ¸¸ç, ÀÌÂ÷¿ø ÁúÀÇ ¿µ¿ªÀÇ ±¸°£ºñ°¡ 1:1024ÀÎ °æ¿ì, ±âÁ¸ÀÇ ¼øȯÀû ºÐÇÒÀü·«À» ÀÌ¿ëÇÏ¿© Á¤¹æÇâ ¸ð¾çÀÇ ÆäÀÌÁö ¿µ¿ªÀ¸·Î ±¸¼ºÇÑ °èÃþ ±×¸®µå ÈÀÏ¿¡ ºñÇØ 7.5qoRKÁöÀÇ ¼º´É°³¼± È¿°ú¸¦ º¸ÀδÙ. ÀÌ·¯ÇÑ ¼º´É °³¼± È¿°ú´Â ÁúÀÇ ¿µ¿ªÀÇ ±¸°£ºñ°¡ Ä¿Áú¼ö·Ï ´õ¿í µÎµå·¯Áö°Ô ³ªÅ¸³´Ù.
|
¿µ¹®³»¿ë (English Abstract) |
This paper presents a physical database design methodology for multidimensional file organizations. Physical database design is the process of determining the optimal configuration of physical files and access structures for a given set of queries. Recently, many multidimensional file organizations have been proposed in the literature. However, there has been no effort for their physical database design. We first show that the performance of query processing is highly affected by the similarity of the shapes between query regions and page regions in the domain space, and then propose a method for finding optimal configuration of the multidimensional file using this property. For performance evaluation, we perform extensive experiments with the multilevel grid file, a multidimensional file organization, using various types of queries and record distributions. The results indicate that the proposed method builds optimal mutlilevel grid files regardless of the query types and record distributions. The performance enhancement shows to be as much as 7.5 times over the conventional method using the cyclic splitting strategy for the query type having the interval ratio of 1:1024. It should be further enhanced for the query types hving higher interval ratios.
|
Å°¿öµå(Keyword) |
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|